Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to copy and past selected rows only...
Hi there, I am very new to this so bear with me
I have 4 excel 97 spreadsheets that I am looking to have the following work in In Col A each row is a formula that says basically if Col D"",Today(),"" To add todays Dat In Col B each row is a formula that says basicaly if Col D"",B1+1,"" (B1 being the row above) To add a consecutive Invoice number Each sheet is updated by a different person and will have a different number of rows on any given day What I need to be able to do is select the number of rows that have data entered into them and Copy+Paste Values of Col A & B. The problem that I am having is that excel sees the formula in the blank cell as data in the cell and selects it as part of the End +down function. I was thinking could right an If...Then macro to loop through and check Col D, if it finds data, then copy and paste values of Cols A & B, but like I said I am very new to this and don't really know how to write new macros. I have been slightly successful in editing macros that I have recorded, but this is a bit beyond me If I need to be more clear, please let me know. Thanks for the input. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy selected rows to second worksheet (NOT Cut + Paste) | New Users to Excel | |||
Macro to Copy/Paste Data into one wksht, skipp one row before past | Excel Discussion (Misc queries) | |||
Macro Help - Copy Selected Row | Excel Discussion (Misc queries) | |||
Copy a selected number of rows | Excel Discussion (Misc queries) | |||
Macro: Insert, copy and past data from sheet | Excel Discussion (Misc queries) |