Data/Form

  • Thread starter Thread starter ~Alan
  • Start date Start date
A

~Alan

Excel has has a built in function Data/Form which allows you to scroll
items in the selected columns
and make changes if necessary.
I have 2 sheets in a workbook named "sheet1" and "parts".
I have to go from sheet1 to sheetParts to use Data/Form to change the
information in sheetparts
then back to sheet1 then back to sheetparts and so on.
Question:
Is it possible to use Data/Form from "sheet1" and have it Data/Form for
"parts"
 
Alt F1

Insert User form. From thier you can create your own forms any way you like

RK
 
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

Cell values to an array, then array transpose to another workbook 8
loop to copy paste 5
sort macro not working 1
Getting information from access table in excel 1
If value occurs more than once then delete all of them 8
data lookup/validation syntax 2
fill in data that is not empty 1
Save As and new workbook new name used in existing code 8

Back
Top