Hello,
Is it possible that excel can copy a template tab and create a new tab automatically when requested?
I am trying to create a spread sheet to log all spends within the department but need to be able to generate a front sheet for each purchase order request. I have attached the spread sheet and have highlighted what I am trying to create.
I have never used visual basics so am completely in the dark, can excel do this sort of thing?
Thanks in advance for any help
Hi
Please see possible solution attached and let me know if it suits your needs.
To create the purchase order simply double click in column L on the row for which you want to create the Purchase Order.
Good luck.
Tony
Similar solution, but with some improvements.
Cheers!
Tsjallie
--------
If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!
If you think design is an expensive waste of time, try doing without ...
Tony,
That works fantastic. That has saved me about a year trying to work it out. Thanks for your help
David
Tsjallie,
This is great. Is it possible to insert a column between Date and Company and Call this Week. I have tried to do this but it changes the formula.
Thanks
David
Yes, that's very well possible. I will look into it when I get home. Will probably introduce named ranges to refer to the columns (they have absolute references).
This makes referencing them more flexible so you can insert or remove columns whilst maintaining the correct references.
Again many thanks.
If I wanted to repeate the layout of the colums and duplicate for 12 months would it be as simple as copying colums A-L in the M-W and so on? Either that or I will link 12 sheets to a master to monitor spends v budget.
Here's the sample which allows you to insert or remove columns whilst still referencing the correct columns.
Guess you're referring to the Summary Sheet. I'm sure that can be done. Guess that would only take a minor adjustment to the macro. Will look into that.If I wanted to repeate the layout of the colums and duplicate for 12 months would it be as simple as copying colums A-L in the M-W and so on?
Do you want the sheet covering all 12 months already or do you want to add new periods only when needed?
Does 1 period equal 1 month?
You are correct 1 period is 1 month. I would like them all in the same place so when I come to review everything it is easier than 12 tabs! I have just copied and pasted the information to make the 12 periods. Is this possible to read from the 1 sheet?
Here's a workbook with all 12 period on sheet.
I did take the liberty to arrange the periods vertically iso horizontally.
As you're not familair with vba I've been looking for a solution without having to introduce more coding.
Further explaination is on the Raised POs sheet.
Hope this works for you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks