Comlicated - maintain data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to get data from a work book (1) to another (2) which is no problem.
The problem is, I have to hold that data by the date and when the date
changes in the same cell, on the same workbook (1), the data is recorded
under the next date in the next cell in workbook 2.

In other words, workbook 1 is being saved as the same file name daily.
Workbook 2 must save the data for each day.

Any assistance would be appreciated.
 
Have you considered having workbook 2 be the source of the data for workbook
1? In this scenario, workbook 1 would have a formula that pulls the latest
data that you enter in workbook 2.
 
You must log in or register to reply here.

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

Similar Threads

Macro to push data to another workbook 0
How to create absolue path link to another workbook (Excel 2003) 1
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Merge Multiple workbook sheets into one workbook 0
Copy Sheet to new Sheet and clear cells on original sheets 7
Linking data within several Workbooks 1
HELP REQUIRED: Vlookup VS separate Workbook 2

Back
Top