29.10.2010
I am using two input data files like SALES and PURCHASES and the third file COMBINED is having cell references to SALES and PURCHASES. SALES and PURCHASES are having month names. Condition is to insert a new column and add the next month and enter the data. In the COMBINED file, instead of month names, M1, M2 are put and cell references are made. Usually if I insert any column in SALES and PURCHASES file, the data typed in the inserted column will not appear in the COMBINED file. My problem is if we insert a new column in SALES and PURCHASES & new month is added, this reference should be reflected in M1 column automatically. Anyone will help me to solve this. P. Venkatesan -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
SALES.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
COMBINED.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
PURCHASES.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
