Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find last column, move formulas over, copy/paste data
Hi -
I am hoping someone can help me find a solution, I have been starring at the computer screen scratching my head for an hour. I have a sheet with Weekending Dates running across Row 1 in Columns B and on. Column A is full of labels that go through row 2 to row 20 (# openings, # hires, # terms..etc). In B2:B20 (and C2:C20..and on) I have many formulas that pull data from another sheet on the workbook. The data is dumped and only includes the current weekending so the workbook does not get to large. I would like to find next Weekending column that is empty, copy the formulas from a hidden column (I haven't made this column yet..) and paste into the empty column, then copy that column and paste values back into the same column to eliminate the formulas and no calculations are needed every time someone else opens the workbook. (Only I update the data....I will then even delete the data to make the book smaller). I hope this makes sense....I am struggling a bit here and would love some advice. Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to find text string in a column and paste data in another | Excel Discussion (Misc queries) | |||
Find text and copy and move row containing it | Excel Discussion (Misc queries) | |||
how to move data down a column, and copy it into a row | Excel Discussion (Misc queries) | |||
Cannot copy or move array entered formulas ... shared workbk | Excel Worksheet Functions | |||
Move C5 to C10 in Excell (no cut/ copy/ paste)? | Excel Discussion (Misc queries) |