Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to read "form"
Hi-
I have a "pretty" excel spreadsheet, that to the users, looks like a form. The top half of the "form" has Company info and the bottom half has a "table" showing multiple serial and model numbers. This has worked wonderfully in a manual system. Now, I would like to learn how to move this data into a "useable" spreadsheet for me, while keeping it "pretty" for the users entering the data. Basically, I need a crash course on how to: -Prompt for what file to look at -Read the top half of that file, placing each needed cell into a new workbook -Loop thru the bottom half of that file, placing each need cell into a row with the above info Befo Auto Parts - Store #1 1234 Hollywood Blvd. 123-456-7890 etc. ------------- Q-Oil 121212 V-Oil 445544 Wiper 383838 Fuse 999999 After: Auto Parts Store #1 1234 Hollywood Blvd. 123-456-7890 Q-Oil 121212 Auto Parts Store #1 1234 Hollywood Blvd. 123-456-7890 V-Oil 445544 Auto Parts Store #1 1234 Hollywood Blvd. 123-456-7890 Wiper 383838 This file I can Pivot and put into Access. I would like to open another file (Store #2) and add that data below Store #1 Any help would be appreciated. If I get a "shell" VBA that is well explained, I hope to be able to tweak the rest (Although this will be me first real VBA code - so go easy on me). Thanks a bunch. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert numbers to date: "586" to read "May 1986" | Excel Worksheet Functions | |||
any formula to convert numbers in word form, e.g. "2" as "Two"? | Excel Worksheet Functions | |||
function to return day in the form "Monday", "Tuesday" etc given . | Excel Worksheet Functions | |||
Solution "Your changes could not be saved" "The document may be read-only or encrypted" | Excel Discussion (Misc queries) | |||
The instruction at "0x65255ac9" referenced memory at "0x00000008". The memory could not be read. Clikc OK to terminate etc | Excel Programming |