Excel Macro for taking data external data and populating it on a sheet and deleting unwanted data
 

I was wondering if anyone had a VBS macro for excel that could do the
following: From a table of external data, sort through the data for a
specific number, export this number and row of contents to a separate
spreadsheet. The spreadsheet would add new values when the external
data is updated. Can someone help me on this one?

Excel Macro for taking data external data and populating it on a sheet and deleting unwanted data
 

We need a lot more information to help you, for example

1. What type of external data is it? Access? SQL?
2. What information do you need?


HTH,
JP

On Nov 6, 5:42 pm, wrote:
I was wondering if anyone had a VBS macro for excel that could do the
following: From a table of external data, sort through the data for a
specific number, export this number and row of contents to a separate
spreadsheet. The spreadsheet would add new values when the external
data is updated. Can someone help me on this one?

Excel Macro for taking data external data and populating it on a sheet and deleting unwanted data
 

On Nov 6, 3:14 pm, JP wrote:
We need a lot more information to help you, for example

1. What type of external data is it? Access? SQL?
2. What information do you need?

HTH,
JP

On Nov 6, 5:42 pm, wrote:



I was wondering if anyone had a VBS macro for excel that could do the
following: From a table of external data, sort through the data for a
specific number, export this number and row of contents to a separate
spreadsheet. The spreadsheet would add new values when the external
data is updated. Can someone help me on this one?- Hide quoted text -


Thanks JP.

I hope I can explain this properly. I want a VBS macro for excel that
will take external data from a table out of a web query. This
particular table will populate and worksheet in the excel. The table
has 12 columns. The colums are set up as followed: Day, Date, Year,
hour, Elevation, Storage, Stage, Discharge, Inflow, Precipitation,
Increment, Temperature. The table is being updated hourly. I would
like the script to look at the table and look at the hour column and
if the hour is 2400 take the row it is in and put it into a new
worksheet. The script needs to be able to insert new values in the
column below existing values imported from the web quary and
dupilcates would not get inserted into the new worksheet. For
example, if the spreadsheet is opened up at the right time, two 2400
values may be showing in the hour column (One value would be from the
current day and one from the previous day that would have already been
imported).

Can you help me out?

Excel Macro for taking data external data and populating it on a sheet and deleting unwanted data
 

On Nov 6, 3:14 pm, JP wrote:
We need a lot more information to help you, for example

1. What type of external data is it? Access? SQL?
2. What information do you need?

HTH,
JP

On Nov 6, 5:42 pm, wrote:



I was wondering if anyone had a VBS macro for excel that could do the
following: From a table of external data, sort through the data for a
specific number, export this number and row of contents to a separate
spreadsheet. The spreadsheet would add new values when the external
data is updated. Can someone help me on this one?- Hide quoted text -

- Show quoted text -

Thanks JP.

I hope I can explain this properly. I want a VBS macro for excel that
will take external data from a table out of a web query. This
particular table will populate and worksheet in the excel. The table
has 12 columns. The colums are set up as followed: Day, Date, Year,
hour, Elevation, Storage, Stage, Discharge, Inflow, Precipitation,
Increment, Temperature. The table is being updated hourly. I would
like the script to look at the table and look at the hour column and
if the hour is 2400 take the row it is in and put it into a new
worksheet. The script needs to be able to insert new values in the
column below existing values imported from the web quary and
dupilcates would not get inserted into the new worksheet. For
example, if the spreadsheet is opened up at the right time, two 2400
values may be showing in the hour column (One value would be from the
current day and one from the previous day that would have already been
imported).

Can you help me out?