Add data from other sheet to the data present in this sheet

N

Nemo

I am trying to add data from another sheet to the data present in this sheet.
I dont know what the formula has to be or how to start. I have 2 sheets,
"today" and "till date". "today" will be updated on a daily basis. I want a
formula where on "till date" sheet, today's data is added to the previous
days dat and show son "till date".... Plz help me...
 
F

Faraz A. Qureshi

How about using a built in form?
Select the complete data with headings on 'Till Data' Sheet
Press "Alt+D" and then O.
Simply add records which will update your sheet as well.
Best o' luck.
 

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

Doughnut Chart linked with the slicer in the pivot table 0
Creating a Chart on form from selected data in query. 0
=IF function with current date 3
How to replace a constant from a cell containing date and time 1
Display Ticket Numbers in Other sheet based on condion 1
Search Sheet Names Across Excel Files 0
Conditional formatting dates 3
Auto Update of Data... help please 1

Top