Printable View
i need to generate the pattern in sheet 1 attached in Book3.xls. does any macro guru have a clue how i can go about generating this ? is there anyone who has worked on such a pattern before ? it wud be really kind if you could provide me some input into this one....
I think you may need to explain a little more.
What is your source data ?
What do you need to do with it?
Can you record a macro as you manipulate it?
Can you recode the macro better?
Vince
Hi Vince,
I spool two oracle reports and get the data.this data is exported to two excel files.then i put both the excel sheets into one workbook(RM and PI) are the two sheets..the basic purpose of generating this model is to foreacast the consumption of parts.these two reports will be run every week..the appropriate total quantity values need to be picked up from the two sheets and displayed under the proper transaction date range for the items common in both sheets......
i can send u the comprehensive excel sheets with more raw data...i urgently need help on this one and i am still a novice at writing macros..am in the learning process....
it wud be kind if you provide me with some feedback
First up, can you do it manually??? I mean get the data together and combined etc..?
If so then thats the first step done.
Second step is to record you actions with the macro record option in tools>Macros menu.
Once recorded you'll see a huge mass of code... not very nice looking but its a start.
Then the confusing bit, you (with the help of us here) decipher the code, group it together, tidy it up and use nicer variables. Then you have a chunk of code you understand (reasonably) good enough to fix and show off :)
How urgent? Like by the end of today or the end of the week?
How much data are you looking at (posting data to other people it should only be test data cause of the data protection act stuff....)...?
Vince
i can get the two sheets onto a single workbook for sure..but then the macro needs to pick up the quantities from the two sheets and generate the format as shown in the pattern...
something other than a macro wud also do..but i feel i will need a macro to generate such a pattern..what do u think ?
i have to do this by tommorrow..
here's what i need to do !