Posts by ArhamRajput

God Bless you.

Thank you so much

Dear Experts,

Your expertise are required i have 1000+ data as i attached below for example.

In first sheet which name is "Data" contains raw data where "X" mean is incomplete.

First i change the "X" with Column header for my working manually (as i did in 1st Example Sheet).

Then filter the data and copy paste it (as i did in 2nd Example sheet)

I am doing this activity since couple of months which takes whole day to complete it.

I am looking for VBA for this task if you guys could help i will be really appreciate it.

looking forward to your response.

Yes it is.

Apologise for replying late.

When i press the button it unhide the sheet when go back then automatically sheet goes hide. i want this and you helped me.

Please help

I'm looking to add formulas to my spreadsheet that can index/match across multiple tabs, and return:

1) Match

2) Next cell beyond the match

3) The previous cell that isn't empty

Below is the Sheet I'm working on. The Info Tab needs to update who the Next Runner is, what time they start, who the second runner is, the time they start, and what time the current runner started.

Please look at this report when i click on the button hide sheet is appear and when i go back then it is disappear.

Thank you for your consistent support.

Thank you so much Roy.

I just need that code will add button later right now not need.

Dear Team,

I am looking for a code when i press a button to initiate the code then hide sheet should be open and should go to on desired cell as hyperlink work.

after that when i press other button to go back then sheet should be hide.

is it possible.

Thank you so much roy.

Because it is related to my work i often count these sheets via CountA formula i know it can be done with single click which can save my time but do not know how to make this vba.

royUK

Yes but above given code is not working.

https://www.mrexcel.com/board/…red.1133725/#post-5484298

By the way thank you i have sort out the issue if you could help me further that i want separately each sheet total along with sheet name.

Thank you but its giving error.

Subscript out of range

Dear Experts,

I need a code which count the particular column across multiple sheets that how many rows have been used in Column "G".

I have appropriate data in column "G" across multiple sheets so i just want that when i use the code Then all sheets count should be showed on new sheet which name would be "SUmmary"

No your code is still no pasting

Roy its not pasting the data in new sheet

Thankyou so much

Dear Experts I want to merge Addsheet code into ExportData code bu could not please help.

Private Sub Export_Data()
Sheet1.Range("B2:G17").Select
Selection.Copy
Worksheets.Add
ActiveSheet.Paste
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, operation:=xlNone, skipblanks:=False, Transpose:=False
Application.CutCopyMode = False
    Range("A1:G14").Select
    With Selection
        .WrapText = True
        .Orientation = 0
        .AddIndent = False
        .IndentLevel = 0
        .ShrinkToFit = False
        .ReadingOrder = xlContext
        .MergeCells = False
    End With
    With Selection
        .WrapText = False
        .Orientation = 0
        .AddIndent = False
        .IndentLevel = 0
        .ShrinkToFit = False
        .ReadingOrder = xlContext
        .MergeCells = False
    End With
    Cells.Select
    Cells.EntireColumn.AutoFit
    
End Sub



Sub AddSheets() 
 Dim NewName As String 
Another: 
 OneMore = False 
 NewName = InputBox("What Do you Want to Name the New Sheet?") 
 Sheets.Add 
 ActiveSheet.Name = NewName 
 If MsgBox("Do you want to Add another Sheet?", vbYesNo) = 6 Then Goto Another 
End Sub

Yeah i can understand but can you please modify this it will be really helpful indeed