Macors

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

H
I have a file in which "sheet 1" gets data from another sheets thru vlookps. Data looks for a name on "sheet 1" and based on that names collects data from other sheets. Names on "sheet 1" are in a drop down list format.
Is it possible to write a macro with which I can print that data for all the names without having to select each name eveytime and then printing it each time
Thank

AJos
 
You can loop through you list of names, and update the cell referenced by
the vlookup, then print the results sheet (where the formulas are) after
each time you change the name in the cell referenced by the vlookup.

--
Regards,
Tom Ogilvy

AJosh said:
Hi
I have a file in which "sheet 1" gets data from another sheets thru
Click to expand...
vlookps. Data looks for a name on "sheet 1" and based on that names collects
data from other sheets. Names on "sheet 1" are in a drop down list format.
Is it possible to write a macro with which I can print that data for all
Click to expand...
the names without having to select each name eveytime and then printing it
each time?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to hide password? 1
Macro to Compile Data from Different Sheets 2
Macro to Combine Data from Multiple Sheets with Cell References 4
Run macro from active workbook whose name keeps changing 20
Create Sheets from a Range and Copy Data on copy Data on newlycreated Sheets with the Sheet Names 2
hide multiple worksheets based on a formula value in one cell 1
Macro for all Excel Workbooks to print to PDF 2
Name the range AFTER copied to new sheet 6

Back
Top