User Profile
danazee
Copper Contributor
Joined Jan 21, 2022
User Widgets
Recent Discussions
Copying a Formula in a workseet to pull data from other worksheets
Hello! I need some help! I have a file that has a worksheet for each day of the month. I also have a sheet that I want to pull key data from each worksheet to create a financial snapshot all in one sheet. I created a column for each day of the month. I have entered the formulas in Day 1 to pull data from the Day 1 worksheet. I want to pull the same data into the other columns (1 column for each days worksheet). How can I copy the formula over without having to manually change it 30 times for each line of data?? For instance, I have "Cash on Hand" and in column 1 I have a formula "=-'1'!$J9 to pull data into that cell from worksheet 1 - cell J9. However, if I copy that formula into columns for day 2, 3, etc. I find that I am having to manually change the "1" in that formula to a "2", then a "3" and it is awfully time consuming. Surely there is an easier way to copy the formula so it pull data from that cell for different worksheets?? I'm attaching a sample file so you can see more easily. My formulas are correct in Column D for Day 1... but I need to pull data for days 2 - 31 as well. Ugh! Would really appreciate your help! I know it's got to be easier than manually changing the formulas 30 times for each line of my summary spreadsheet! At least I hope so!! TIA!!539Views0likes2CommentsHow to Compile Data More Efficiently
Hello! Need some help from an Excel wizard! I need to pull our restaurants sales data by menu item so we know what was sold on a daily basis and can reconcile this against our inventory counts. I can pull the report in our system. However, what I am doing now is putting each day on it's own sheet since the data isn't going to be the same each day. For instance, we may sell crab legs one day but not another. For ease of analysis, it would be great if I could get it all on one sheet. But I can't figure out how to do it without entering the data manually, one menu item at a time. Is there an easier, more efficient way to do this? I'm attaching a file so you have an example. I'd appreciate any help I can get with this! TIA!!956Views0likes1CommentHow to Calculate Total Hours Worked
I want to create a spreadsheet where my staff enters the time they worked on individual tasks (note: I don't need start and end time, just total time on each task) and keep a running total of hours worked for that day, then get a total for the entire week. I've tinkered around with the formulas but can't seem to get it to work correctly. Can one of you Excel geniuses help me out?? Thanks in advance!!!Solved11KViews0likes3CommentsHow to Copy Formulas From Different Worksheets
I am trying to simplify the inventory sheets we are using to make the process easier. In an excel file, I will have one sheet for each date we take inventory. We create the sheet each week that inventory is taken by copying the sheet before it. There is some data I need from the prior week such as beginning inventory and last week's food costs. I entered the formulas into worksheet #2 and all's good. However, when I copy that worksheet to create my next inventory sheet (for the following week) it still pulls data from worksheet #1. I also tried copying and pasting but the same result. Not sure how to set it up so that it pulls from the sheet before it and not from the first sheet? The data I need to 'roll-over' each week is highlighted in blue. I was hoping not to have to change the formulas for each sheet ... because what would be the point? I don't see a way to upload the file here, so https://docs.google.com/spreadsheets/d/13B6iF1XvYjvuOIBydDsqMpLAE4TbNjPp/edit?usp=sharing&ouid=101172493561105318867&rtpof=true&sd=true. Would be appreciative of the help here!1.7KViews0likes4Comments
Recent Blog Articles
No content to show