Hi,
Please provide a formula to get this working as per attached sheet
Input 1:01.03.2013 values are 10,15 and 20
Input 2:07.03.2013 values are 14,19,23
then it should create 6 values with input 1 and 1 values with input 2 in a new worksheet
excel.xlsx
Last edited by udayg10; 03-04-2013 at 07:13 AM.
Is this solved?
If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
no its not solved...might have saved incorrectly
Are there chances of having multiple inputs or just 2 inputs?
there can be multiple inputs but the format is the same
Try this code - clear the data in the Outpot sheet (except for headers) and run the macro -
Copy the Excel VBA code
Please Login or Register to view this content.
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste
To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks