Doesn't matter who the author is
i included an attachment in my original post and tried to make it as clear as a i could, perhaps understand that due to my lack of ability with Excel / VBA i may not be asking in the most efficient way or using the correct terminology but i tried to explain it...
i never said i was the author of the sheet, and i couldn't see any data in the sample spreadsheet i initially upload and still cannot now. i also won't be insulted when all i am trying to do is ask for some help, you might consider being slightly less condescending next time you reply to...
i need the table if that's what you mean. listen i appreciate your help and that you've taken your own time to look at this for me but at this stage it might be best to just leave it i especially do not like being referred to as 'Dumb' the reason people come to this forum is to get help if we...
The formula's were in the sample workbooks i sent across. the second one you posted worked like a charm, the one i inserted into the Sheet10 module.
i know but this will be a weekly thing so the 'Master' would be saved with a new filename hence the end of the name being WC.
That works. Thank you so much!!!!
The only other question i have is on the source sheets in column B14 down the name is determined by a formula - =IF($B$3="","",$B$3)
Is there anyway of copying this value over, not the formula but the name it shows. it works where it has been typed in...
i could but i don't see how that would solve my problem i would still have to manually copy and paste the data in which was the thing i wanted to avoid in the first place. thank you anyway
right OK, thank you i wasn't aware the code would be different if i was pasting into a table, this is where my lack of ability with VBA comes in
at the moment i have to manually copy the data from around 60 spreadsheets into the table on the master spreadsheet which takes me around an hour and...
because thats where i want the data from the chase updates sheets to be pasted into so that i can update the graphs on the other sheets, i'm aware of what a table and it's purpose is and yes i need it as a table bu if i didnt would that change was i would be asked for i would still want the...
we use one master spreadsheet that has the tables in and at the moment we copy and paste the data from the chase updates sheets into the master.
i'm not 100% sure what you mean by clean workbooks but the sheets are filled in weekly.
the data copied should be pasted into the same range int my...
Hi,
I’m after some assistance creating the correct VBA to do the following:
· There will be several workbooks stored in the same location (with different filenames but they should start with ‘Chase updates’) C:\Users\SmithJ\Documents\Spreadsheets
· In these workbooks is a sheet called...