/docs/community?hl=en
This content is likely not relevant anymore. Try searching or browse recent questions.
I would to combine two sheets into one and be able to use that as a master sheet.
1
I used cut, copy, paste. I also used also used Merge Sheets v3.0. It is a monthly budget that I downloaded for free. I would like to combine the two sheets, while retaining their functions, and make it a master sheet. Then each month, duplicate the master and name it after each month. Thank you in advance.

Details
Pinned
Locked
Latest Update Latest Updates (0)
Relevant Answer Relevant Answers (0)
All Replies (5)
Relevant Answer
Jerri,
 
Can you explain in more detail what you are trying to achieve, and what is and isn't working currently?
First, I assume that Summary is just a locked copy of the Merged Sheets tab?
 
From what I can see, you are entering both expenses and income in the Transactions tab.
These are then being correctly used by the Merged Sheets tab to fill the Actual values.
And the rest of the Merged Sheets tab calculates the difference of Actuals to Planned, and provides some summary values.
 
I'm not sure what you mean by combining the two, unless you mean you want to enter the income and expense transactions directly on the Merged Sheets tab?  I don't know what benefit that provides, but is that because you then want to "freeze" and save each month's data, with its summary output?
 
If I unerstand your objective correctl, my recommendation would be that instead you add a "reporting" option on your Merged Sheets tab to select which month you want to view, or current year to date, or previous year, all without changing the format of that summary page.  The data would all be read and filtered (as needed) from the Transactions tab, which would be the historical collection of all your raw data.  Potentially, that could be partially automated to come from a bank or credit card statement/file.
 
I'll look for your response.
Cheers,
Gill
marked this as an answer
Relevant Answer
This is the original


This is what the end result to be. 


I think I see the problem, but don't know hot to fix it. When I either cut, copy & paste or merge it, this formula will not work because it is looking for the "Transactions" workseet. It states "error, argument must be a range".
All of column E & F have these errors.

=if(isblank($B22), "", sumif(Transactions!$E:$E,$B22,Transactions!$C:$C))

I hope this helps.

Jerri
marked this as an answer
Relevant Answer
Gil you are a gentleman and a scholar!!! Thank you soooo much! It works exaactly as I wished it would. Many thanks.


Cheers,
Jerri
marked this as an answer
Relevant Answer
Jerri,
 
I'm so glad I could help, and thanks for the feedback and recommendation.  Much appreciated by us volunteer contributors here on the forum!
 
Post back anytime with new questions - we’re all still learning!
 
Cheers,
Gill
marked this as an answer
This question is locked and replying has been disabled.
Discard post? You will lose what you have written so far.
Write a reply
10 characters required
Failed to attach file, click here to try again.
Discard post?
You will lose what you have written so far.
Personal information found

We found the following personal information in your message:

This information will be visible to anyone who visits or subscribes to notifications for this post. Are you sure you want to continue?

A problem occurred. Please try again.
Create Reply
Edit Reply
This will remove the reply from the Answers section.
Notifications are off
Your notifications are currently off and you won't receive subscription updates. To turn them on, go to Notifications preferences on your Profile page.
Report abuse
Google takes abuse of its services very seriously. We're committed to dealing with such abuse according to the laws in your country of residence. When you submit a report, we'll investigate it and take the appropriate action. We'll get back to you only if we require additional details or have more information to share.

Go to the Legal Help page to request content changes for legal reasons.

Reported post for abuse
Unable to send report.
Report post
What type of post are you reporting?
Google takes abuse of its services very seriously. We're committed to dealing with such abuse according to the laws in your country of residence. When you submit a report, we'll investigate it and take the appropriate action. We'll get back to you only if we require additional details or have more information to share.

Go to the Legal Help page to request content changes for legal reasons.

Reported post for abuse
Unable to send report.
This reply is no longer available.
/docs/threads
//accounts.google.com/ServiceLogin
You'll receive email notifications for new posts at
Unable to delete question.
Unable to update vote.
Unable to update subscription.
You have been unsubscribed
Deleted
Unable to delete reply.
Removed from Answers
Removed from Updates
Marked as Recommended Answer
Marked as Update
Removed recommendation
Undo
Unable to update reply.
Unable to update vote.
Thank you. Your response was recorded.
Unable to undo vote.
Thank you. This reply will now display in the answers section.
Link copied
Locked
Unlocked
Unable to lock
Unable to unlock
Pinned
Unpinned
Unable to pin
Unable to unpin
Marked
Unmarked
Unable to mark
Reported as off topic
Known Issue
Fixed
Marked Fixed
Unmarked Fixed
Unable to mark fixed
Unable to unmark fixed
/profile/0
false
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
35
false