Challenging Task Ahead

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.
 
B

Bob Bridges

LostInNY, this strikes me as a good place to violate the usual rule about
telling us all the relevant information; instead, I suggest you rewrite this,
paring out the parts you already know how to do and posing just the questions
you need help on, each in a separate post. This'll benefit you and the rest
of us in two ways: 1) We won't waste our time (and yours too for that
matter) telling you how to do the parts you already understood, and 2) we
won't look at a long project and turn away, discouraged because it looks like
too much work. YOU have to do all that work, but we don't; if I see one
question I'm more likely to tackle it than if I see four. And also 3) by
breaking up the questions into a bunch of small ones, you'll get each
question answered by people who feel qualified to answer that question alone
-- you get better expertise in other words.

What I mean by eliminating the parts you already understand is this: You
already know (I presume) how to save a sheet as a CSV, putting a time stamp
in its file name. So don't mention that part; just ask (for example) "What's
the best way to eliminate blank lines from a worksheet before I save it as a
CSV?". Make that a separate post from the others; that way you'll probably
get quicker answers.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top