I have this code here that works when i go through the debugger and then when i run the macro it doesn't work. I have removed some titles for sensitive reasons, but the structure is intact.
Sub Disseminate()
Dim RefName As String
Dim RefDate As String
Dim Names As Integer
Dim I As Integer
Dim...
which is better, keeping raw data in its original format or making it into a table and why?
I use these tables for crossreferencing to reports and metrics. Size of the file is also an issue.
I am trying to get the userform textbox to automatically change when the user selects a different cell on the worksheet(like an event change), and the value of the selection now becomes the value used in the code as well as being displayed in the textbox.
Wow, had to change "=B2" to ="A2", but it works great. also, had to make it an array formula.
Thank you so very much.
=IFERROR(INDEX($I$2:$I$23,MATCH(1,($B$2:$B$23=A2)*NOT(ISBLANK($I$2:$I$23)),0)),"")
I have a list of Customers in column B. In column I i have an alternate name. the alternate name once given is always the same. The customer's name can appear multiple times becuase of different dates they visit, but the alternate name might appear on the 6th visit and that is all. what formula...
I am trying to convert daily hour charging into months(sometimes data goes over into different years, like December then to January) how can i have excel automatically know if there are hours charged in a certain range to automatically include all months and appropriate years? i have used the...
yeah, VBA, i have a chart sheet so i can do chart events, I have a list of parts. different people build the parts. I am looking at their time charged to each part. i want to know who charged the less. so when i look at the bar graph of the product, i click on the bar, i can then see who charged...
If memory serves correctly i believe there was a tutorial on how to create graphs and make them selectable. for example. i have a bar graph that gives me total sales. i can then click on that bar and get detailed info about what info goes to that bar. any suggestions?
Thanks
I have a complex spreadsheet. i want to create back up files but without any formulas. I have special formatting and charts. how can i go about this? I have tried doing a vba savacopyas. it works however, i still have all the formulas. i then tried to reopen it and then go through the...
sorry about the format, it pasted that way and i didn't adjust it. i tried using the conditional format and becuase of the size of the range, it really bogs the spreadsheet. can you assist on the reference concepts. that would be very helpful. I think that that concept is my crux right now.
I have written a code to open a workbook on a network and calculate a QTY through sumifs formula with 2 criteria. I have 6000 parts and 10 products i am comparing the network file against. the network file is about 70,000 lines. i have tried looping the formula several ways. one line item and...
I want some generic code to copy a field in project and paste it into excel. I need the generic syntax and i can change to what i need. i am just lost on the initial code.
Thank you,
Greg
Hello Sajan,
I am at a production facility. we have decided to go forward to provide MS project schedules for each end item. there are about 700 individual tasks that need to be accomplished. from these project files i need to gather schedule information as well as % complete information. so...
I got the copy to work, here is the new problem. i keep getting reference issues now. it will work one moment then not another. i will look at the html idea and get back with you.
thanks
I am trying to create metrics from my project file, but i am having trouble linking to my project file for automatic updates. can someone help please. I have done a copy and paste link text but only certain columns are pasted and not everything i copied.
Thanks
I am trying to count inventory. i have the product in columns F,G,H and so on. I have the parts that make the product in column B. in addition, i use multiple parts in different assemblies to make this part. meaning, i could use a part 2 or 3 times (like screws). I need to create an inventory...
unfortunately, I am unable to post. i think the problem still lies in the array formula. double click the cell where the formula is, then select ctrl + shift+ enter and it should work.
http://chandoo.org/wp/2012/07/03/find-the-last-date-of-an-activity/
this may help in explaining the array...