I need to collect data from different sheets on a single sheet in a workbook which have same cell no. but different sheet no. I tried it with using copy paste technique n fix the cell no. with $ but their is no change in sheet no.
plzz help me with it , is their any other formula for doing this?
Menu
Query related Excel
Replies (5)
Quick Summary
Use = from different sheets.
Their is almost 200 something sheet it will take too time, is their any other trick or way to do this in short tym?
U can use copy special function where u can keep the values only
I tried it , it only paste the values but I want to paste formula as well with changing sheet reference and not changing cell reference
Oh.. okay here u can try
1,copy paste
2.select all where pasted
3.hen change ur sheet number using replace all to desired one.
1,copy paste
2.select all where pasted
3.hen change ur sheet number using replace all to desired one.
Recent Topics :
- Investment fund's income from ncd distribution to
- Cialis 20 mg – General Information About Tad
- Comparative BS PL with Audit report
- Source of funds in IT returns
- Work from home job
- TDS ON ANY PURCHASE OF ANY GOODS - 393(1)
- TDS on payment to a non resident
- NSFA(National Food Security Act) commission
- RCM applicability on petty GTA freight (₹450
- Short payment reccieved in export & GST implic
Related Topics :
09 September 2026
Semi Qualified CA / CA Inter - 2 Groups Cleared
Getmyca Consultant Pvt Ltd
New Delhi
CA Inter
View Details
ARTICLESHIP
15 September 2026
Freelance Taxation Content Writer Intern
Interactive Media Pvt Ltd.
New Delhi
CA Inter
View Details
22 September 2026
Account Assistant
Chirag P Shah & Co. Chartered Accountant
Pune
B.Com
View Details
08 September 2026
Semi-Qualified Assitant
Subrahmanyam & Sivudu CA Firm
Hyderabad
CA Inter
View Details
ARTICLESHIP
30 September 2026
CA Article Assistant
CA Suraj Garg & Associates
New Delhi
CA Final
View Details
CCI
Pro
CAclubindia
