Hi,
Now even sure how to head this query up. Please see attached sample spreadsheet.
I have a costs listings by nominal by title. Each of these titles has a number of issues. What I would like to do is create a list of costs by nominal for each of the issues.
E.g.
ABBSIN0901 412100 83.33
ABBSIN0902 412100 83.33
And so on for all 12 issues
The bit on bold represents the issue number.
I am struggling to know where to begin with this one. Help much appreciated as always.
Thanks
Matt
SystemsAccountant,
Having trouble understanding your requirements.
Please post another workbook, with Sheet2 completed manually to represent the output you are looking for from/on Sheet1.
Have a great day,
Stan
Have a great day,
Stan
Windows 10, Excel 2007, on a PC.
If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
Hi Stanley,
As requested please find attached a new spreadsheet with the data I would like to see on another sheet.
Many Thanks
Matt
SystemsAccountant,
What does the "0901" in "JABBSIN0901" represent?
Have a great day,
Stan
09 Represents the Order Year - I can put this in the code myself if needed.
01 Represents the Issue Number. ABBSIN has 12 issues which is why the I need a sequence that runs from 0901, 0902, 0903..... to 0912.
Each Title has a number of issues and I need to split the budget (per account) by issue.
Regards
Matt
*bump*
If I need to re explain this please let me know?
SystemsAccountant,
Here you go - see the attached workbook "Copy of Costs By Issue VB Query - SystemsAccountant.xls".
To run the macro, press and hold down the CTRL + SHIFT keys, and press the C key.
Or, click on "Tools", "Macro", "Macros...", make sure the "Macros in:" box says "This Workbook", and in the "Macro Name:" box, click on "CopyCosts", and click on the "Run" button.
The macro will ask for the "Order Year".
Your original data is in Sheet1, and the new report will be in Sheet2.
Have a great day,
Stan
Brilliant, many thanks Stanley.
I would never have been able to figure that out.
I am trying to alter it slightly as my source data isn't quite the same as that supplied, i.e. the starting row and column are slightly different. I have tried changing what I thought I needed to do this but the macro seems to fail.
My actual data is offset by 2 rows and 2 columns compared to the data I gave.
Matt
SystemsAccountant,
Please post another workbook with real data.
Have two sheets, the original data (modified for confidentiality) with the original sheetname, and the updated data worksheet with the original sheetname.
With the updated data worksheet with the original sheetname, please manually show what the data should look like.
Have a great day,
Stan
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks