Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Updating sheets to include new data beside old data
I need to update spreadsheets containing data in a varying number o cells (eg, sometimes the sheet will contain data in A-E, A-G etc) t show new data alongside old data (eg, 2003's data alongside 2002' data) I need to be able to search the sheet for the data and move the entir data to the right by the appropriate number of cells to allow room fo new data of the same size to be entered in the now empty cells. Ideally the macro would do this no matter how many columns the data i in. Thanks in advanc ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Include info from data source in data table but not in chart | Charts and Charting in Excel | |||
Data Range updating automatically as new data is entered | Charts and Charting in Excel | |||
updating external data sheet causes loss of data on linked pages | Excel Worksheet Functions | |||
Need help updating my macro to include a 2nd worksheet. | Excel Worksheet Functions | |||
Updating Excel Data on Multiple Sheets | Excel Worksheet Functions |