Autofill Down and Across based on Data on another Worksheet

[uberathlete]

Hi everyone, and Happy New Year! I was hoping to for some assistance with a problem.

Basically, all I would like to do is run a macro that grabs data from another worksheet.

Please see attached.

In WORKSHEET, there is a blue highlighted area. Those cells should be populated with data in the Parts Usage tab. Basically, column D should list a Part, column E the Quantity, and column F the Price or rate.

The desired result is in the Result tab. I basically just entered a formula then autofilled down and across. Is there a way to do this in VBA? Any suggestions would be much appreciated.

[xlbiznes]

Are you trying to automate the complete invoicing process so that you can have a template that will extract data for parts usage and other details and generate an invoice based on the invoice number ?

Based on your sample file, the requirement seems to be to just pull data from one sheet and paste it into another.
A simple cell reference will do the job if your parts list is not going to exceed 8 items.

[uberathlete]

Are you trying to automate the complete invoicing process so that you can have a template that will extract data for parts usage and other details and generate an invoice based on the invoice number ?

Based on your sample file, the requirement seems to be to just pull data from one sheet and paste it into another.
A simple cell reference will do the job if your parts list is not going to exceed 8 items.

Actually yes, I am trying to automate the whole process. I get a Parts Usage report and the data in that report (part, quantity, and price) should appear in the template. The parts list could be more or less than 8 items, so the template should hopefully adjust to that.

[xlbiznes]

looking at the part usage report, the invoice number is not a part of this list.

Now when you want to fill in your invoice with the parts we need to have a reference number by which we can search the data and populate your template.

[xlbiznes]

Have a look at this file to see how it can be achieved.

[uberathlete]

Have a look at this file to see how it can be achieved.

Hi x1biznes. I have amended my original workbook (Excel Problem 3 Amended.xlsx in the first post‎) . What I did was extend the invoice template down and reference the parts in Parts Usage. If there is no part (ie. it references a blank in the Parts Usage sheet), then return "NONE".

However, I would like to delete the range that contains "NONE" (ie. A14:G26 and not entire rows). Would it be possible to do this action with VBA?

[xlbiznes]

try this, this will clear the rows that have none in it.

[uberathlete]

try this, this will clear the rows that have none in it.

Awesome! Thank you thank you thank you!!!

[uberathlete]

Yikes. How do i mark this thread as Solved? Sorry moderators. Kindly advise.

[xlbiznes]

Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.