Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pulling "Irregular Shaped" Data from Excel
I have made a simple vlookup calculator that analyses a block of data from an
Excel report (exported from another program) which uses data (specifically selected) pasted from that report into a "field" of the calculator sheet. (lost you yet?) It works great, however that is a lot of pasting for our soon to be peak season where this will be done +200 times in one day... The issue is that the data is irregular and continues in 'blocks" for pages. What I mean is, that the data being analysed is not the same number of rows per set. Block "A" might be 5 lines, and block "B" might be 10. (plus it is in the middle of merged cells further complicating things) I am not sure how to go about selecting the right area automatically if I were to try to write a Macro to neatly process and organize needed data. It would not be possible to just skip every so many rows. It will be a project for me, and I know a person knowledgable with macros could probably come up with something easily enough. I just am not sure where to begin on the issue of selecting specific data. It may be best to give an example, and would be happy to send one if it will make things easier. Thanks! - Alden |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pulling "Irregular Shaped" Data from Excel
OK, I'll bite - send a sample workbook as an email attachment to (remove
spaces) HelpFrom @ jlatham site.com No promises - and I need a good definition of the 'rules' associated with determining what constitutes a block of information, and how to identify start/end of such blocks. And I'm NOT going to type in a bunch of sample data myself - provide it in the workbook/sheet(s). "Alden" wrote: I have made a simple vlookup calculator that analyses a block of data from an Excel report (exported from another program) which uses data (specifically selected) pasted from that report into a "field" of the calculator sheet. (lost you yet?) It works great, however that is a lot of pasting for our soon to be peak season where this will be done +200 times in one day... The issue is that the data is irregular and continues in 'blocks" for pages. What I mean is, that the data being analysed is not the same number of rows per set. Block "A" might be 5 lines, and block "B" might be 10. (plus it is in the middle of merged cells further complicating things) I am not sure how to go about selecting the right area automatically if I were to try to write a Macro to neatly process and organize needed data. It would not be possible to just skip every so many rows. It will be a project for me, and I know a person knowledgable with macros could probably come up with something easily enough. I just am not sure where to begin on the issue of selecting specific data. It may be best to give an example, and would be happy to send one if it will make things easier. Thanks! - Alden |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hot to calculate peaks of an "irregular" sine wave | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Pulling "Matrix" Data | Excel Programming | |||
Help! Boss needs this ASAP - I am pulling out my hair here folks use of "&" in HEADER | Excel Worksheet Functions | |||
Adding "New" "Insert" "Delete" into a workbook to change from data 1 to data 2 etc | Excel Programming |