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

B

bkmn4u

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?
 
J

JP

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
 
B

bkmn4u

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

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?
 
B

bkmn4u

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



- 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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top