Take data from a form and fill an array

June 3, 2009 at 12:23:41
Specs: Windows XP
I want to take data from specific Excel cells on a worksheet form and have that data transfered to a new worksheet (array) each time the form is "accepted". Seems easy, just been about 20 yrs since programming...

See More: Take data from a form and fill an array

Report •


#1
June 3, 2009 at 12:39:03
each time the form is "accepted"
What do you mean?

To copy data from one sheet to another simply specify the other sheet. IE

On sheet 1 cell a1 you have todays date
On sheet 2 cell b1 simply put the formula sheet1!a1 and cell b1 now has the same info as sheet 1 cell a1.

Also if you post Excel questions in the Office Software forum you might get a larger response.

MIKE

http://www.skeptic.com/


Report •

#2
June 3, 2009 at 12:59:50
Thanks. I don't want to just reference back to the same cell contents, but rather make the first sheet like a form where data is entered (name, date, condition, ...) then hit a button and have that information stored into an array on the second sheet so that I have a searchable history of a specific condition. The user would then enter new info on the same first sheet, hit the button, and the array would now have two rows. I might have finally tracked some info down via microsoft, but all suggestions are welcome

Report •

#3
June 3, 2009 at 13:15:10

Report •

Related Solutions

#4
June 3, 2009 at 15:02:55
Got it, thanks. I found an example at Microsoft as you suggested for filling a dynamic array. Think I can move forward now...

Report •

#5
June 3, 2009 at 15:21:06
Don't forget to post Excel questions in the Office Software forum.
Good luck.

MIKE

http://www.skeptic.com/


Report •


Ask Question