L
LostInNY
I just received a difficult assignment and I am going to need some help. I
have a workbook with 10 spreadsheets (sheet1-sheet11) which could contain up
to 10,000 rows each. Sheet 1 updates information on sheets 2-9 and sheet 10
is a summary page of all the data and sheet 11 is a continuous roll up of all
data old and new. Since sheet10 only contains what is currently enter in
sheets1-9, we copy and paste any new information to sheet 11 for our rolling
log.
I need the workbook to perform the following whenever the user saves it:
1. Update spreadsheet(sheet11) in the same workbook by copying all new data
in sheet 10 to sheet 11. I'm not sure if a Vlookup is best and create a new
row for what doesn't exist?
2. Create new CSV files for sheets 2-9 in separate workbooks and name each
CSV after the name on the tab in the original workbook. When the CSVs are
created they need to have all duplicates(Columns 1-6) removed and all empty
lines removed. We are getting empty lines because of the formulas in the
cells from the original spreadsheets and it causes errors for us when we use
it for other applications. The CSV should also be created in the same folder
as the original workbook.
3. Update an existing workbook with a new excel spreadsheet. The new
spreadsheet is a copy of sheet 10 from the original workbook. The new tab
name needs to be a date and time stamp.
have a workbook with 10 spreadsheets (sheet1-sheet11) which could contain up
to 10,000 rows each. Sheet 1 updates information on sheets 2-9 and sheet 10
is a summary page of all the data and sheet 11 is a continuous roll up of all
data old and new. Since sheet10 only contains what is currently enter in
sheets1-9, we copy and paste any new information to sheet 11 for our rolling
log.
I need the workbook to perform the following whenever the user saves it:
1. Update spreadsheet(sheet11) in the same workbook by copying all new data
in sheet 10 to sheet 11. I'm not sure if a Vlookup is best and create a new
row for what doesn't exist?
2. Create new CSV files for sheets 2-9 in separate workbooks and name each
CSV after the name on the tab in the original workbook. When the CSVs are
created they need to have all duplicates(Columns 1-6) removed and all empty
lines removed. We are getting empty lines because of the formulas in the
cells from the original spreadsheets and it causes errors for us when we use
it for other applications. The CSV should also be created in the same folder
as the original workbook.
3. Update an existing workbook with a new excel spreadsheet. The new
spreadsheet is a copy of sheet 10 from the original workbook. The new tab
name needs to be a date and time stamp.