Hello Everyone,
Hi this is Mukesh. I have a issue regarding the automatically update data from one sheet(sheet1) to another sheet(sheet2). Could you please give me the solution are send me the example excel sheet which includes 10 columns in sheet1 and 10 columns in sheet2.
Thank you,
K.Mukesh
Hi Mukesh,
I need to understand what you are requesting on this excel, since the sheet 1 contains total calls or queries handled but sheet 2 contains break up.
You have no matching data? What would your expected outcome look like?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
When I enter data in sheet1 it automatically gets updated into sheet2 with the same column name.
Based on what? In sheet2 you have a bunch of names, where did they come from and how do they relate to anything from sheet1?
IF you just want to pull the data in from sheet1, with noting to relate to, try this, copied down and across...
=IF(Sheet1!A2="","",Sheet1!A2)
If thats not what you wanted, please explain again
Based on what? In sheet2 you have a bunch of names, where did they come from and how do they relate to anything from sheet1?
IF you just want to pull the data in from sheet1, with noting to relate to, try this, copied down and across...
=IF(Sheet1!A2="","",Sheet1!A2)
If thats not what you wanted, please explain again
Could you please send me a sample example excel sheet which includes sheet1 and sheet2.
Actually I need when we enter a data in sheet1 it automatically update into sheet2 with the same name are same column name or row name etc.
check this attachment.. let me know this is what you wanted...
I suggest that you upload a WB that contains better samples of what you are working with, and what your expected outcome is
Hello Venkat,
The attachment Excel file is not working. Could you please resend the same sample file.
Regards,
K.Mukesh
mukeesh123, did you read post 9?
Also, the file downloads ok for me, but the contents make no sense in relation to your question
Hello Venkat and FDibbins,
I am attaching the sample file. could you please enter the data in sheet1 and it should be directly updated into sheet2 with the same name or same column. As example on attached sheet we have a phonecalls column in sheet1 and it directly updated the same phonecalls column name in sheet2 like wise I need all columns should be updated in attached sheet.
Thank you,
K.Mukesh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks