Seeing that I'm using Excel 2000,I have 3 workbooks containing 547sheets altogether, each representing a machine number. Every day I run a macro retrieving data/machine (547queries) pasting the results “as is” into these workbooks. (The sheet names matching the number of the machines) This is my a basic data list called “WholePageDataPerMachine.xls” from which I want to filter the data to different workbooks. Every time I run the macro the data gets pasted into A:A inserting a new column for where the next data will be pasted. I’m running the macro 3 or 4 times a day now, retrieving data, but would eventually like to do this every hour. My problem is this: <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>
I’m getting an uneven display of the data across the sheet. Depending on the time of the query and whether updating is in progress or not on the web, the outlay of the data in each column on the same sheet is slightly different. This “extra data” is data that I don’t need, but it’s moving the data that I do need to different cells across the sheet, resulting in taking up too much time to delete the empty rows before I can actually sort the data that I do need into the same rows to get a specific cell reference, leaving me drowning in data to sort.<o></o>
Is there anyway somebody could please help me?<o></o>
This is more or less what my sheet looks like:<o></o>
A B C D E etc<o></o>
1 row 1 displays machine number (data needed-always same row)<o></o>
2 data not needed - same row<o></o>
3 empty row - always<o></o>
4 empty row - always<o></o>
5 heading – always – not needed<o></o>
6 empty row - always<o></o>
7 row 7 displays relevant date for this specific data (needed- always same place)<o></o>
8 time or updating in progress message - if time – next 2 rows data - if message – next 2 rows empty. <o></o>
It looks like after the last cell entry they have 3 empty rows before the next heading, so if I get a message in row 8, 3 empty rows will follow before the next heading in row 12, but if I have time in row 8, 2 rows with data will follow, then three empty rows and then next heading will be in row 14<o></o>
9 if row 8 displays time - data needed are displayed here, if message in row 8 – empty row<o></o>
10 data not needed or empty row<o></o>
11 empty row
12 next heading empty <o></o>
13 data not needed empty<o></o>
14 next heading after a time display in row 8 followed by 2 rows data<o></o>
15 data not needed/or empty
16 data not needed/or empty
17 heading (3 rows after last entry) data not needed/or empty
18 1 row after heading empty data not needed/or empty
19 5 rows of needed data to follow heading (3 rows after last entry)
20 needed data
21 needed data
22 needed data
23 needed data
24 links and data not needed
25
26 links and data not needed<o></o>
27<o></o>
28<o></o>
29<o></o>
30 usually no more than row 30 entries across sheet
ANY HELP would be greatly appreciated.
Thank you in advance.
fficeffice" /><o></o>I’m getting an uneven display of the data across the sheet. Depending on the time of the query and whether updating is in progress or not on the web, the outlay of the data in each column on the same sheet is slightly different. This “extra data” is data that I don’t need, but it’s moving the data that I do need to different cells across the sheet, resulting in taking up too much time to delete the empty rows before I can actually sort the data that I do need into the same rows to get a specific cell reference, leaving me drowning in data to sort.<o
></o>Is there anyway somebody could please help me?<o
></o>This is more or less what my sheet looks like:<o
></o>A B C D E etc<o
></o>1 row 1 displays machine number (data needed-always same row)<o
></o>2 data not needed - same row<o
></o>3 empty row - always<o
></o>4 empty row - always<o
></o>5 heading – always – not needed<o
></o>6 empty row - always<o
></o>7 row 7 displays relevant date for this specific data (needed- always same place)<o
></o>8 time or updating in progress message - if time – next 2 rows data - if message – next 2 rows empty. <o
></o>It looks like after the last cell entry they have 3 empty rows before the next heading, so if I get a message in row 8, 3 empty rows will follow before the next heading in row 12, but if I have time in row 8, 2 rows with data will follow, then three empty rows and then next heading will be in row 14<o
></o>9 if row 8 displays time - data needed are displayed here, if message in row 8 – empty row<o
></o>10 data not needed or empty row<o
></o>11 empty row
12 next heading empty <o
></o>13 data not needed empty<o
></o>14 next heading after a time display in row 8 followed by 2 rows data<o
></o>15 data not needed/or empty
16 data not needed/or empty
17 heading (3 rows after last entry) data not needed/or empty
18 1 row after heading empty data not needed/or empty
19 5 rows of needed data to follow heading (3 rows after last entry)
20 needed data
21 needed data
22 needed data
23 needed data
24 links and data not needed
25
26 links and data not needed<o
></o>27<o
></o>28<o
></o>29<o
></o>30 usually no more than row 30 entries across sheet
ANY HELP would be greatly appreciated.
Thank you in advance.
