LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sony Manoj
 
Posts: n/a
Default DELETE DUPLICATE DATA IN A SHEET AUTOMATICALLY

Hi there

If somebody can help me with this. I have a sheet which contians volumes
pertaining to companies on a monthly basis. My system gives me data per
month. The columns in worksheet are Co Name, Volumes for Jan,Feb,March and
so on. After completing data for the month of Jan, I copy volumes for Feb
into the same sheet. The sheet already contains data for eg for ABC for Jan
and for Feb that i hv copied just now in two diff columns and rows. I want to
run a formula that will place my Feb figure for ABC in a column next to Jan
w/out manually copying and pasting Feb figure into the column next to Jan.
you hav to consider that I also have new co's every month whose data has to
exist as it is.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using a relative SHEET reference for source data in a chart James Charts and Charting in Excel 6 August 16th 05 05:07 PM
Automatically pasting worksheet data to new worksheet with formulas COntactJason Excel Worksheet Functions 0 August 10th 05 08:22 PM
Printing data validation scenarios SJC Excel Worksheet Functions 14 July 24th 05 12:43 AM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM
Function to automatically insert a new sheet as a result of data entry? Mark Mulik Excel Worksheet Functions 2 November 28th 04 02:21 AM


All times are GMT +1. The time now is 02:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"