Automate insert data

  • Thread starter Thread starter Anupam
  • Start date Start date
A

Anupam

In sheet1 i am updating data for a particular row. The new recorded I
have updated should be inserted in the existing sheet for that record.

For eg.
In sheet 1 there is following Data

Name Date Details
X 14/05 213.......
Y 14/05 3200000...

There is separate sheet for X having following data

Date Details
12/05 123000..
13/05 12....
14/05 32.....

& similarly for Y

I will update sheet 1 with Details for X & Y on 17/05

The new details should be reflected in the sheet for X and also there
should be no duplication of dates, so that if I run code for second time
it should not update. Only when for new date details are there and I run
the code the data should be inserted.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins &
Software!http://www.ozgrid.com/Services/excel-software-categories.htm **
 
It sounds like you want to steal some code from Debra Dalgleish's site:

http://www.contextures.com/excelfiles.html

Look for:

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- creates a list of unique items,
creates a sheet for each item, then replaces old data with current.
AdvFilterCity.xls 46 kb

and

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Back
Top