Macro to dump data onto sheet

Hello

I require some assistance for a macro that will simply move data from one worksheet to "G.S Report" worksheet.

I receive montly files (August Raw data, September Raw data...December Raw data), which I simply copy paste into the raw data file (copy/paste).

would like:
-a macro once data is copied into the i.e. August Raw data worksheet (I have left AUgust and September populated in the sample), so simply paste or dump their data onto the G.S Report worksheet with links to the Raw data sheet.
-I have provided an example for the month of June and july.

so basically, I would liek each month's data to be dropped right below one another and on the last cell of each month in the G.S. Report, make a border line to show month end (see example) in G.S Report worksheet

Can someone pls help!

I'm very new with macros so I would be gratefull for this help!

On row 1446 in the G.S report worksheet I have provided one example i.e. row and metrics i want to be carried over from "August Raw data" sheet.

thx u so much!

*run macro "unprotect" to unprotect sheet

Just look through the attached file: there are much different between the column title from G.S Report sheet and August... Sheet; How to combine them?

Plz, left the clarity-explaining,

Originally Posted by jw01

any thoughts guys?

Try the solution (download the attached file)

Plz take mention to the sheet "RUN Pr" , and the comments in some cells, and try to familiar with the layout of flashible parameters for the sub. It is easy to change the column and the way you make formulas in the sheet report

Press Make Report button to runt the macro

any question more you can post here, I will try to explain,

i hope you can easily to manage it

Originally Posted by jw01

1) i had to insert columns and rows on the Run Pr worksheet so it is currently throwing the macro out of order....

Okie, now I write the code corresponding to the name for cell: C11 C1, D5 (define name, you can see by press Ctrl+F3) , so now you can insert any row except for keep form block of parameters.

Originally Posted by jw01;2585512
2) in my original file, i have other worksheets that contain August, September, so is it possible for the macro to lookup worksheet that contain month + raw (i.e. August Raw data, September Raw data)[B

so pick up the second word as well[/B]?

The macro picks up whole name of the source-sheets at C15,C16,... as well as of the Des.-Sheet. So don't worry about it. (I mean the first word of the source-sheets'name for the month is only written in Col C at Des.sheet)
see the new version in the attached file.


A recommendation for you
in my opinion, your data is very large, so you should consider to change all the dynamic formula to Value, in other word, these cells containing live formula should be calculated by VBA then converted to VALUE (store in the file) --> it will make your file faster

Originally Posted by jw01

hey bud

final request....how i make column R copy down the formula as well?

currently it is
R Nothing

You need only change E21 from "Nothing" to ""Fomula" - you also see the instruction at the comment of E5 (in sheet "RUN Pr")

Originally Posted by jw01

hey bud,

is it possible if i select august raw data, it deletes the first set of entries for the month (i.e. august in this case), and overwrites only the august or select month raw data?

Now the macro will excutive for:

finding the August (in case, any month is list as source-sheet) in Report-Sheet, if it has (if NOT found the new data will add the last row in sheet report)

and Ask if the user is sure DELETE old data or NOT Delete??
----- if YES it will their set of old (you should remember "August" is at column C should continue cells and unique in Column C sheet Report)
---- if NO --> keeping the old data (the new data will be added following the old data)

then insert the New Data from Sheet-source (August in this case)

=> now you can update the august event the September or October filled the data, or update new Set of data for July, June,...

Of course, the macro is correct for any month and you can run more one month (source-sheet) each time


Note: Old set of data (all records) in the selected month in sheet Report is deleted so plz take care fully when you choose YES for delete the old data BECAUSE there is no undo

Plz download the new version attached file