0 votes
in VBA by Beginner (26 points)

I have two sheets 
1. Output
2. Data

  •  i need to get the product code in Output sheet using VLOOKUP from Data sheet till LROW. (If Product code is not available in Data sheet cell should be blank in Output sheet)
  • add total amount in output sheet from Data sheet using SUMIFS till LROW.
Thank you !Test

1 Answer

0 votes
by Expert (911 points)
You do not need VBA for this. You have already outlined the formulas for Output sheet.
by Beginner (26 points)
Yes,  formula will help to complete the above steps, but I'm looking for VBA for this to auto mate one repetitive task, as i have huge data and i have to do some other validation after these steps.

Thank you !
by Expert (911 points)
Just a suggestion: Put the formulas in Output sheet, then use VBA for "some other validation."

Welcome to wellsr Q&A
Ask any questions you have about VBA and Python and our community will help answer them. wellsr Q&A is the standalone question and answer platform for wellsr.com. If you have a question about one of our specific tutorials, please include a link back to the tutorial.

Getting Started
VBA Cheat Sheets (On Sale Now)

Looking for something else? Hire our team directly through ourVBA Help page, instead.

For more programming tips visit the VBA Tutorials Blog and the Python Tutorials Blog.