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?
5 Replies
Aakansha Jain
(18 Points)
Replied 24 November 2020
Their is almost 200 something sheet it will take too time, is their any other trick or way to do this in short tym?
SiJo JoSe
(24 Points)
Replied 24 November 2020
U can use copy special function where u can keep the values only
Aakansha Jain
(18 Points)
Replied 25 November 2020
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
SiJo JoSe
(24 Points)
Replied 26 November 2020
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
- Applicability of REG 07 and TDS on metal scrap
- Sale Order v. Purchase order
- Income tax 143(1) after scrutiny
- Best Practices for Managing Finances in Online Gam
- FREELANCING ACCOUNTANT
- Refund Recovery Alert: IT Department Using AI to D
- Rule 47A CGST
- How can I check the platform number for my train?
- Gratuity under CTC
- GST refund paid as estimated tax liability
Related Threads
CAclubindia
