I have a file with forms for each day of the month, sheet names 1 to 30/31.
I would like to be able to paste this IFERROR(IF(INDEX('1'!$C$50:$Q$75,MATCH($C4,'1'!$C$50:$C$75,0),2)="Shut-in","",INDEX('1'!$C$50:$Q$75,MATCH($C4,'1'!$C$50:$C$75,0),$A$2+2)),"")
to other cells, with update of sheet. This is sheet 1 obviously; but when I copy it across the page, is stays as sheet 1, when I want it to progressivly update to sheet 2, 3, ..... etc.
I'm sure its a simple solution, but not for me!!!!
Hi, welcome to the forum
That is 1 of the shortcomings of copying between sheets - the sheet reference wont adjust
1 way around that would be to use INDIRECT(), but that can become resource-intense if used too much. Can I ask why you feel the need to a sheet per day, instead of 1 sheet for all data, then use summary sheet/s to extract the data as needed?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi Ford
Good to be in forum.
I receive daily report sheets from the field and want to consolidate some of the (more important) data into monthly and annual reports for quick look purposes, rather than opening every sheet.
Regards
It sounds like you already add the daily files to your "master" file? If you do, then it might be simpler to just put each day's data below the previous day's data, the run summaries from that?
Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like, then I can show you what I mean
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks